Office® 2013 eLearning Kit For Dummies® by Faithe Wempen

Office® 2013 eLearning Kit For Dummies® by Faithe Wempen

Author:Faithe Wempen
Language: eng
Format: epub
ISBN: 9781118490327
Published: 2014-01-22T14:18:39+00:00


In cell B5, type =B3/.

Click the Expenses tab, click cell B15, and press Enter. The display jumps back to the Overall tab and completes the formula, as shown in Figure 6-7.

Figure 6-7

Save the changes to the workbook and close it.

Leave Excel open for the next exercise.

Moving and Copying Formulas

In Chapter 5, you learn how to move and copy text and numbers between cells, but when it comes to copying formulas, beware of a few gotchas. The following sections explain relative and absolute referencing in formulas and how you can use them to get the results you want when you copy.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.